Version: 8.4.08.4

SpdrRiskGroupControl

METADATA

Attribute	Value
Topic	4535-risk-control
MLink Token	SystemData
Product	SRTrade
accessType	SELECT,UPDATE,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
riskGroupId	CHAR(19)	PRI	'0000-0000-0000-0000'
accnt	VARCHAR(16)	PRI	''
riskFirm	VARCHAR(16)	PRI	''	SR client firm
sysEnvironment	enum - SysEnvironment		'None'	original source sys environment Stable Current etc
runStatus	enum - RunStatus		'None'	original source run status ProdBeta
isDisabled	enum - YesNo		'None'	will disable all trading in this risk group parent orders will cancel existing child orders and suspend new child orders
expDayWtVegaOffset	FLOAT		-1	max acctsymbol day wtVega offset target
maxExpDayWtVegaLn	FLOAT		-1	max accntexpiration day time weighted vega long positive number1no limitrisk limit max limit current net counter offset
maxExpDayWtVegaSh	FLOAT		-1	max accntexpiration day time weighted vega short positive number1no limitrisk limit max limit current net counter offset
maxExpDayRMetric6Ln	FLOAT		-1	max acctexpiration day rMetric6 long positive number1no limitrisk limit max limit current net counter
maxExpDayRMetric6Sh	FLOAT		-1	max acctexpiration day rMetric6 short positive number1no limitrisk limit max limit current net counter
symDayDDeltaOffset	FLOAT		-1	max acctsymbol day delta offset target
maxSymDayDDeltaLn	FLOAT		-1	max acctsymbol day delta long positive number1no limitrisk limit max limit current net counter offset
maxSymDayDDeltaSh	FLOAT		-1	max acctsymbol day delta short positive number1no limitrisk limit max limit current net counter offset
symDayVegaOffset	FLOAT		-1	max acctsymbol day vega offset target
maxSymDayVegaLn	FLOAT		-1	max acctsymbol day vega long positive number1no limitrisk limit max limit current net counter offset
maxSymDayVegaSh	FLOAT		-1	max acctsymbol day vega short positive number1no limitrisk limit max limit current net counter offset
symDayWtVegaOffset	FLOAT		-1	max acctsymbol day wtVega offset target
maxSymDayWtVegaLn	FLOAT		-1	max acctsymbol day time weighted vega long positive number1no limitrisk limit max limit current net counter offset
maxSymDayWtVegaSh	FLOAT		-1	max acctsymbol day time weighted vega short positive number1no limitrisk limit max limit current net counter offset
maxSymDayRMetric7Ln	FLOAT		-1	max acctsymbol day rMetric7 long positive number1no limitrisk limit max limit current net counter
maxSymDayRMetric7Sh	FLOAT		-1	max acctsymbol day rMetric7 short positive number1no limitrisk limit max limit current net counter
maxGrpDayContractsLn	INT		-1	max acctriskGroup day opt contracts long positive number1no limitrisk limit max limit current net counter
maxGrpDayContractsSh	INT		-1	max acctriskGroup day opt contracts short positive number1no limitrisk limit max limit current net counter
maxGrpDayContractsAbs	INT		-1	max acctriskGroup day opt contracts abs positive number1no limitrisk limit max limit abscurrent net counter
maxGrpDayDDeltaLn	FLOAT		-1	max acctriskGroup day delta long positive number1no limitrisk limit max limit current net counter
maxGrpDayDDeltaSh	FLOAT		-1	max acctriskGroup day delta short positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaLn	FLOAT		-1	max acctriskGroup day vega long positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaSh	FLOAT		-1	max acctriskGroup day vega short positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaAbs	FLOAT		-1	max acctriskGroup day vega abs positive number1no limitrisk limit max limit abscurrent net counter
grpDayVegaRatio	FLOAT		1.0	target bot sld ratio eg ratio20 means that neutral is bot vega 2x sld vega
maxGrpDayRMetric1Ln	FLOAT		-1	max acctriskGroup day rMetric1 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric1Sh	FLOAT		-1	max acctriskGroup day rMetric1 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric1Abs	FLOAT		-1	max acctriskGroup day rMetric1 abs positive number1no limitrisk limit max limit abscurrent net counter
grpDayRMetric1Ratio	FLOAT		1.0	target bot sld ratio eg ratio05 means that neutral is bot rMetric1 05x sld rMetric1
maxGrpDayRMetric2Ln	FLOAT		-1	max acctriskGroup day rMetric2 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric2Sh	FLOAT		-1	max acctriskGroup day rMetric2 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric3Ln	FLOAT		-1	max acctriskGroup day rMetric3 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric3Sh	FLOAT		-1	max acctriskGroup day rMetric3 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric4Ln	FLOAT		-1	max acctriskGroup day rMetric4 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric4Sh	FLOAT		-1	max acctriskGroup day rMetric4 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric5Ln	FLOAT		-1	max acctriskGroup day rMetric5 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric5Sh	FLOAT		-1	max acctriskGroup day rMetric5 short positive number1no limitrisk limit max limit current net counter
accEmaCxlDDeltaLn	FLOAT		-1	max acct 60s EMA delta long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
accEmaCxlDDeltaSh	FLOAT		-1	max acct 60s EMA delta short positive number 0 is no limit
accEmaCxlWtVegaLn	FLOAT		-1	max acct 60s EMA wtVega long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
accEmaCxlWtVegaSh	FLOAT		-1	max acct 60s EMA wtVega short positive number 0 is no limit
symEmaCxlDDeltaLn	FLOAT		-1	max acctsymbol 60s EMA delta long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
symEmaCxlDDeltaSh	FLOAT		-1	max acctsymbol 60s EMA delta short positive number 0 is no limit
symEmaCxlWtVegaLn	FLOAT		-1	max acctsymbol 60s EMA wtVega long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
symEmaCxlWtVegaSh	FLOAT		-1	max acctsymbol 60s EMA wtVega short positive number 0 is no limit
modifiedBy	VARCHAR(24)		''
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
riskGroupId	1
accnt	2
riskFirm	3

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRRiskGroupControl` (
    `riskGroupId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `riskFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR client firm',
    `sysEnvironment` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None' COMMENT 'original (source) sys environment [Stable, Current, etc]',
    `runStatus` ENUM('None','Prod','Beta','UAT','SysTest') NOT NULL DEFAULT 'None' COMMENT 'original (source) run status [Prod,Beta]',
    `isDisabled` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'will disable all trading in this risk group (parent orders will cancel existing child orders and suspend new child orders)',
    `expDayWtVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day wtVega offset (target)',
    `maxExpDayWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max accnt+expiration day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
    `maxExpDayWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max accnt+expiration day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
    `maxExpDayRMetric6Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+expiration day rMetric6 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxExpDayRMetric6Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+expiration day rMetric6 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `symDayDDeltaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta offset (target)',
    `maxSymDayDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
    `maxSymDayDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
    `symDayVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega offset (target)',
    `maxSymDayVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
    `maxSymDayVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
    `symDayWtVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day wtVega offset (target)',
    `maxSymDayWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
    `maxSymDayWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
    `maxSymDayRMetric7Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day rMetric7 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxSymDayRMetric7Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day rMetric7 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayContractsLn` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayContractsSh` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayContractsAbs` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
    `maxGrpDayDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day $delta long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day $delta short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayVegaAbs` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
    `grpDayVegaRatio` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'target bot / sld ratio (eg ratio=2.0 means that neutral is bot vega = 2x sld vega)',
    `maxGrpDayRMetric1Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayRMetric1Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayRMetric1Abs` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
    `grpDayRMetric1Ratio` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'target bot / sld ratio (eg ratio=0.5 means that neutral is bot rMetric1 = 0.5x sld rMetric1)',
    `maxGrpDayRMetric2Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric2 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayRMetric2Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric2 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayRMetric3Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric3 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayRMetric3Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric3 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayRMetric4Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric4 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayRMetric4Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric4 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `maxGrpDayRMetric5Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric5 long (positive number;-1=no limit);risk limit = max limit - current net counter',
    `maxGrpDayRMetric5Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric5 short (positive number;-1=no limit);risk limit = max limit + current net counter',
    `accEmaCxlDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct 60s EMA $delta long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
    `accEmaCxlDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct 60s EMA $delta short (positive number; <= 0 is no limit)',
    `accEmaCxlWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct 60s EMA wtVega long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
    `accEmaCxlWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct 60s EMA wtVega short (positive number; <= 0 is no limit)',
    `symEmaCxlDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA $delta long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
    `symEmaCxlDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA $delta short (positive number; <= 0 is no limit)',
    `symEmaCxlWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA wtVega long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
    `symEmaCxlWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA wtVega short (positive number; <= 0 is no limit)',
    `modifiedBy` VARCHAR(24) NOT NULL DEFAULT '',
    `modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    CONSTRAINT nonnegative_riskGroupId CHECK(ASCII(riskGroupId) < 56),
    PRIMARY KEY USING HASH (`riskGroupId`,`accnt`,`riskFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `riskGroupId`,
    `accnt`,
    `riskFirm`,
    `sysEnvironment`,
    `runStatus`,
    `isDisabled`,
    `expDayWtVegaOffset`,
    `maxExpDayWtVegaLn`,
    `maxExpDayWtVegaSh`,
    `maxExpDayRMetric6Ln`,
    `maxExpDayRMetric6Sh`,
    `symDayDDeltaOffset`,
    `maxSymDayDDeltaLn`,
    `maxSymDayDDeltaSh`,
    `symDayVegaOffset`,
    `maxSymDayVegaLn`,
    `maxSymDayVegaSh`,
    `symDayWtVegaOffset`,
    `maxSymDayWtVegaLn`,
    `maxSymDayWtVegaSh`,
    `maxSymDayRMetric7Ln`,
    `maxSymDayRMetric7Sh`,
    `maxGrpDayContractsLn`,
    `maxGrpDayContractsSh`,
    `maxGrpDayContractsAbs`,
    `maxGrpDayDDeltaLn`,
    `maxGrpDayDDeltaSh`,
    `maxGrpDayVegaLn`,
    `maxGrpDayVegaSh`,
    `maxGrpDayVegaAbs`,
    `grpDayVegaRatio`,
    `maxGrpDayRMetric1Ln`,
    `maxGrpDayRMetric1Sh`,
    `maxGrpDayRMetric1Abs`,
    `grpDayRMetric1Ratio`,
    `maxGrpDayRMetric2Ln`,
    `maxGrpDayRMetric2Sh`,
    `maxGrpDayRMetric3Ln`,
    `maxGrpDayRMetric3Sh`,
    `maxGrpDayRMetric4Ln`,
    `maxGrpDayRMetric4Sh`,
    `maxGrpDayRMetric5Ln`,
    `maxGrpDayRMetric5Sh`,
    `accEmaCxlDDeltaLn`,
    `accEmaCxlDDeltaSh`,
    `accEmaCxlWtVegaLn`,
    `accEmaCxlWtVegaSh`,
    `symEmaCxlDDeltaLn`,
    `symEmaCxlDDeltaSh`,
    `symEmaCxlWtVegaLn`,
    `symEmaCxlWtVegaSh`,
    `timestamp`
FROM `SRTrade`.`MsgSRRiskGroupControl`
WHERE 
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `riskFirm` = 'Example_riskFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRTrade`.`MsgSRRiskGroupControl` 
SET
    /* Replace with a ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') */ 
    `sysEnvironment` = 'None',
    /* Replace with a ENUM('None','Prod','Beta','UAT','SysTest') */ 
    `runStatus` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `isDisabled` = 'None',
    /* Replace with a FLOAT */
    `expDayWtVegaOffset` = 1.23,
    /* Replace with a FLOAT */
    `maxExpDayWtVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxExpDayWtVegaSh` = 1.23,
    /* Replace with a FLOAT */
    `maxExpDayRMetric6Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxExpDayRMetric6Sh` = 1.23,
    /* Replace with a FLOAT */
    `symDayDDeltaOffset` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayDDeltaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayDDeltaSh` = 1.23,
    /* Replace with a FLOAT */
    `symDayVegaOffset` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayVegaSh` = 1.23,
    /* Replace with a FLOAT */
    `symDayWtVegaOffset` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayWtVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayWtVegaSh` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayRMetric7Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxSymDayRMetric7Sh` = 1.23,
    /* Replace with a INT */
    `maxGrpDayContractsLn` = 5,
    /* Replace with a INT */
    `maxGrpDayContractsSh` = 5,
    /* Replace with a INT */
    `maxGrpDayContractsAbs` = 5,
    /* Replace with a FLOAT */
    `maxGrpDayDDeltaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayDDeltaSh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayVegaSh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayVegaAbs` = 1.23,
    /* Replace with a FLOAT */
    `grpDayVegaRatio` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Sh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Abs` = 1.23,
    /* Replace with a FLOAT */
    `grpDayRMetric1Ratio` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric2Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric2Sh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric3Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric3Sh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric4Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric4Sh` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric5Ln` = 1.23,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric5Sh` = 1.23,
    /* Replace with a FLOAT */
    `accEmaCxlDDeltaLn` = 1.23,
    /* Replace with a FLOAT */
    `accEmaCxlDDeltaSh` = 1.23,
    /* Replace with a FLOAT */
    `accEmaCxlWtVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `accEmaCxlWtVegaSh` = 1.23,
    /* Replace with a FLOAT */
    `symEmaCxlDDeltaLn` = 1.23,
    /* Replace with a FLOAT */
    `symEmaCxlDDeltaSh` = 1.23,
    /* Replace with a FLOAT */
    `symEmaCxlWtVegaLn` = 1.23,
    /* Replace with a FLOAT */
    `symEmaCxlWtVegaSh` = 1.23,
    /* Replace with a DATETIME(6) */
    `timestamp` = '2022-01-01 12:34:56.000000'
WHERE
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `riskFirm` = 'Example_riskFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSRRiskGroupControl`(
    /* Replace with a CHAR(19) */
    `riskGroupId`,
    /* Replace with a VARCHAR(16) */ 
    `accnt`,
    /* Replace with a VARCHAR(16) */ 
    `riskFirm`,
    /* Replace with a ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') */ 
    `sysEnvironment`,
    /* Replace with a ENUM('None','Prod','Beta','UAT','SysTest') */ 
    `runStatus`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `isDisabled`,
    /* Replace with a FLOAT */
    `expDayWtVegaOffset`,
    /* Replace with a FLOAT */
    `maxExpDayWtVegaLn`,
    /* Replace with a FLOAT */
    `maxExpDayWtVegaSh`,
    /* Replace with a FLOAT */
    `maxExpDayRMetric6Ln`,
    /* Replace with a FLOAT */
    `maxExpDayRMetric6Sh`,
    /* Replace with a FLOAT */
    `symDayDDeltaOffset`,
    /* Replace with a FLOAT */
    `maxSymDayDDeltaLn`,
    /* Replace with a FLOAT */
    `maxSymDayDDeltaSh`,
    /* Replace with a FLOAT */
    `symDayVegaOffset`,
    /* Replace with a FLOAT */
    `maxSymDayVegaLn`,
    /* Replace with a FLOAT */
    `maxSymDayVegaSh`,
    /* Replace with a FLOAT */
    `symDayWtVegaOffset`,
    /* Replace with a FLOAT */
    `maxSymDayWtVegaLn`,
    /* Replace with a FLOAT */
    `maxSymDayWtVegaSh`,
    /* Replace with a FLOAT */
    `maxSymDayRMetric7Ln`,
    /* Replace with a FLOAT */
    `maxSymDayRMetric7Sh`,
    /* Replace with a INT */
    `maxGrpDayContractsLn`,
    /* Replace with a INT */
    `maxGrpDayContractsSh`,
    /* Replace with a INT */
    `maxGrpDayContractsAbs`,
    /* Replace with a FLOAT */
    `maxGrpDayDDeltaLn`,
    /* Replace with a FLOAT */
    `maxGrpDayDDeltaSh`,
    /* Replace with a FLOAT */
    `maxGrpDayVegaLn`,
    /* Replace with a FLOAT */
    `maxGrpDayVegaSh`,
    /* Replace with a FLOAT */
    `maxGrpDayVegaAbs`,
    /* Replace with a FLOAT */
    `grpDayVegaRatio`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Ln`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Sh`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric1Abs`,
    /* Replace with a FLOAT */
    `grpDayRMetric1Ratio`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric2Ln`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric2Sh`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric3Ln`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric3Sh`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric4Ln`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric4Sh`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric5Ln`,
    /* Replace with a FLOAT */
    `maxGrpDayRMetric5Sh`,
    /* Replace with a FLOAT */
    `accEmaCxlDDeltaLn`,
    /* Replace with a FLOAT */
    `accEmaCxlDDeltaSh`,
    /* Replace with a FLOAT */
    `accEmaCxlWtVegaLn`,
    /* Replace with a FLOAT */
    `accEmaCxlWtVegaSh`,
    /* Replace with a FLOAT */
    `symEmaCxlDDeltaLn`,
    /* Replace with a FLOAT */
    `symEmaCxlDDeltaSh`,
    /* Replace with a FLOAT */
    `symEmaCxlWtVegaLn`,
    /* Replace with a FLOAT */
    `symEmaCxlWtVegaSh`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'Example_riskGroupId',
    'Example_accnt',
    'Example_riskFirm',
    'None',
    'None',
    'None',
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    5,
    5,
    5,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    1.23,
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgSRRiskGroupControl` 
WHERE
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `riskFirm` = 'Example_riskFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrRiskGroupControl' ORDER BY ordinal_position ASC;

METADATA​

Table Definition​

PRIMARY KEY DEFINITION (Unique)​

CREATE TABLE EXAMPLE QUERY​

SELECT TABLE EXAMPLE QUERY​

UPDATE TABLE EXAMPLE QUERY​

INSERT TABLE EXAMPLE QUERY​

DELETE TABLE EXAMPLE QUERY​

Doc Columns Query​

METADATA

Table Definition

PRIMARY KEY DEFINITION (Unique)

CREATE TABLE EXAMPLE QUERY

SELECT TABLE EXAMPLE QUERY

UPDATE TABLE EXAMPLE QUERY

INSERT TABLE EXAMPLE QUERY

DELETE TABLE EXAMPLE QUERY

Doc Columns Query